package org.tc.product.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.security.access.method.P;
import org.springframework.web.bind.annotation.RequestBody;
import org.tc.product.entity.Joincommoditys;

public interface JoincommoditysMapper {
    int deleteByPrimaryKey(Integer id);

    int insertJoin(@RequestBody Joincommoditys record);

    Joincommoditys selectByPrimaryKey(Integer id);

    List<Joincommoditys> selectAllJoin(@Param("firstResult") int firstResult, @Param("pageSize") int pageSize, @Param("storeid") Integer storeid);

    int updateByPrimaryKey(@RequestBody Joincommoditys record);

    int getJoinCount(@Param("storeid") Integer storeid);

    List<Joincommoditys> QueryMonthJoin(@Param("starttime")String starttime,
                                      @Param("jointime") String jointime,
                                      @Param("storeid") Integer storeid);

    List<Joincommoditys> QueryDayJoin(@Param("jointime") String jointime,
                                      @Param("storeid") Integer storeid);

    int QueryCountJoin(@Param("starttime")String starttime,
                                        @Param("jointime") String jointime,
                                        @Param("storeid") Integer storeid);

    int QueryDayCountJoin(@Param("jointime") String jointime,
                          @Param("storeid") Integer storeid);

}